SQL for Data Science

Published

May 1, 2020

Learn How to Setup SQLite

Review the set-up instructions as well in preparation for class.

SQLite

There are many flavors of SQL but most flavors have the same base commands. SQL queries are typed in the following pattern;

SELECT -- <columns> and <column calculations>
FROM -- <table name>
  JOIN -- <table name>
  ON -- <columns to join>
WHERE -- <filter condition on rows>
GROUP BY -- <subsets for column calculations>
HAVING -- <filter conditions on groups>
ORDER BY -- <how the output is returned in sequence>
LIMIT -- <number of rows to return>

The reading for this task are from this excellent SQL Guide. To prepare for class and this task you should read:

  • All the categories in the “Basic” group. (topics are grouped in the menu on the left side of the page).

  • The following sections in the Intermediate group:

Back to top